package com.example.demo.mapper;

import com.example.demo.model.Provider;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

/**
 * Created with IntelliJ IDEA.
 * Description:
 * User: fzykd
 * Date: 2023-03-07
 * Time: 11:39
 */

@Mapper
public interface ProviderMapper {

    //查询供应商数据
    List<Provider> selectAll();

    //查询指定编码
    Provider selectByCode(String code);

    //根据proName查询
    Provider selectProName(String ProName);

    //条件查询
    Provider conditionSelect(String proAddress,String proDesc);


    //新增一条数据
    int add(Provider provider);


    //修改数据
    int updateName(Provider provider);

    //根据公司名字删除
    int removeName(String proName);
}
